package com.hyst.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.hyst.model.PersonProducePlanView;

public interface Person_Produce_Plan_Repository extends JpaRepository<PersonProducePlanView, String> {
	@Query(value = "select * from person_produce_plan_view where worker_id = ?1 and plan_begin_time >= ?2 and plan_finish_time <= ?3", nativeQuery = true)
	List<PersonProducePlanView> findAllByUserID(String worker_id,String starttime,String endtime);
}
